package com.cc.mapper;

import com.cc.entity.EmployeeAttendance;
import com.cc.entity.Employees;

import java.util.List;

/**
* @author 33314
* @description 针对表【employees(员工基本信息表)】的数据库操作Mapper
* @createDate 2025-05-30 08:34:49
* @Entity com.cc.entity.Employees
*/
public interface EmployeesMapper {

    int deleteByPrimaryKey(Long id);
    //    新增员工
    int insert(Employees record);

    int insertSelective(Employees record);

    Employees selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Employees record);

    int updateByPrimaryKey(Employees record);
//  查询所有员工数量
    int selectCounts();
//    通过id查询员工信息
    Employees selectById(String empNo);
//    根据姓名模糊查询
    List<Employees> selectByName(String name);
//    通过考勤倒序查询
    List<Employees> selectByAttendanceDesc();
//    删除离职状态员工信息
    int deleteEmployeesStatus();
//    根据员工工号查询员工信息(包括该员工的考勤记录)
    Employees selectByEmployeeNo(String employeeNo);


}
